---
title: DB-CLL-030 — Retrieve a single other-legal-party record
summary: Retrieve a single other-legal-party record
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-030 — Retrieve a single other-legal-party record

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-030 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsOtherLegalParty |
| Criteria property | RetrieveSQL |
| Lifecycle method | AfterRetrieve |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalCaseID | Input | NUMBER | N/A | Legal case identifier the other-party row belongs to |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | SELECT | LEGAL_CASE_SEQ_NUM, all LEGAL_CASE_EMPLOYER columns |

## Sample SQL

```sql
Select
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_EMPLOYER_SEQ_NUM as OtherPartyID,
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_SEQ_NUM as LegalCaseID,
  LEGAL_CASE_EMPLOYER.EMPLOYER_OTHER_FIRM_SEQ_NUM as EmployerOtherFirmSeqNum,
  LEGAL_CASE_EMPLOYER.ATTORNEY_OTHER_FIRM_SEQ_NUM as AttorneyOtherFirmSeqNum,
  LEGAL_CASE_EMPLOYER.ATTORNEY_LEGAL_PERSON_SEQ_NUM as AttorneyLegalPersonSeqNum,
  LEGAL_CASE_EMPLOYER.EMPLOYER_DISCOVERY_FLAG as EmployerDiscoveryFlag,
  LEGAL_CASE_EMPLOYER.ATTORNEY_DISCOVERY_FLAG as AttorneyDiscoveryFlag
From
  LEGAL_CASE_EMPLOYER
Where
  LEGAL_CASE_EMPLOYER.LEGAL_CASE_SEQ_NUM = :LegalCaseID
```

## Operations and processes

- [Manage other legal parties and request issues](../operations/manage-other-legal-party-and-request-issue.md)

## Sources

- `SAIF.Business.Claim.Legal\LegalNet\clsOtherLegalParty.vb`